Mega Code Archive
Database SQL JDBC
1) A common intermediate format for a non-XA JDBC pool
2) A database MetaData query
3) A general-purpose SQL interpreter program
4) A method to get the current date and time to use in a timestamp
5) A method to get the current date to use in a timestamp
6) A trivial example of a database query performed with JDBC
7) Access MySQL Database
8) Accounts
9) Adding a New Column Name in Database Table
10) All data types for Oracle
11) Another Method To Check Table Existance
12) Applet and Oracle JDBC
13) Applet JDBC
14) Arrange a Column of Database Table
15) Batch update
16) Batch Update Demo
17) Batch update for MySQL
18) Batch Update Insert
19) Blob
20) Blob and JDBC
21) Boolean java sql Driver jdbcCompliant()
22) Boolean java sql DriverPropertyInfo required (Is property value required)
23) Cached RS
24) Call a function with one IN parameter; the function returns a VARCHAR
25) Call a function with one INOUT parameter; the function returns a VARCHAR
26) Call a function with one OUT parameter; the function returns a VARCHAR
27) Call a procedure with one IN parameter
28) Call a procedure with one INOUT parameter
29) Call a procedure with one OUT parameter
30) Call a stored procedure with no parameters and return value
31) Call stored procedure
32) Call Stored Procedure In MySql
33) Call Stored Procedure In Oracle And Pass In Out Parameters
34) Calling a Function in a Database
35) Calling a Stored Procedure in a Database with no parameters
36) Cancelling Updates to an Updatable Result Set
37) Change Column Name of a Table
38) Change the fetch size on the result set
39) Check Batch Update Result
40) Check if cursor is in the first row
41) Check JDBC Installation for MySQL
42) Check JDBC Installation for Oracle
43) Commit or rollback transaction in JDBC
44) Committing and Rolling Back Updates to a Database
45) Compare two times
46) Concurrency in ResultSet
47) Connect to a database and read from table
48) Connect to a database via JDBC-ODBC
49) Connect to an Oracle database with JDBC
50) Connect to cloudscape
51) Connect to database and call stored procedure
52) Connect to more than one database
53) Connecting to a SQLServer Database using the NetDirect JDBC driver
54) Construct java sql Timestamp from string
55) Convert a ResultSet to XML
56) Convert a timestamp (= millisecs) to a concise string
57) Convert an Object to a DateTime, without an Exception
58) Convert an Object to a java sql Time
59) Convert an Object to a Timestamp, without an Exception
60) Convert into java sql Time (or into java util Calendar)
61) Convert java sql Timestamp to long for easy compare
62) Convert String To Timestamp
63) Convert Strings to Dates and Timestamps and vice versa
64) Convert WebRowSet To String
65) Converting a java sql Types integer value into a printable name
66) Copy data from one table to another in a database
67) Copy One Database Table to Another
68) Count Records Using PreparedStatement
69) Count Records using the Prepared Statement
70) Count row in Oracle
71) Count rows in MySQL
72) Create a batch update in JDBC
73) Create a connection to MS Access database
74) Create a DataStore, initially empty
75) Create a function named myfunc which returns a VARCHAR value; the function has no parameter
76) Create a function named myfuncin which returns a VARCHAR value; the function has an IN parameter named x
77) Create a function named myfuncinout that returns a VARCHAR value
78) Create a function named myfuncout which returns a VARCHAR value
79) Create a scrollable result sets
80) Create a sensitive scrollable result set
81) Create a table in database
82) Create an insensitive scrollable result set
83) Create Coffees table
84) Create Connection With Properties
85) Create Custom RowSet MetaData
86) Create data table
87) Create data table 2
88) Create data table 3
89) Create data type and data table
90) Create Database for MySQL
91) Create Employee Table Oracle
92) Create new data type
93) Create procedure myprocin with an IN parameter named x
94) Create procedure myprocinout with an INOUT parameter named x; x is an IN parameter and an OUT parameter
95) Create procedure myprocout with an OUT parameter named x
96) Create supplier table
97) Create table
98) Create table for mysql database
99) Create Table With All Data Types In MySQL
100) Create table with foreign key
101) Create table with primary key
102) Create WebRowSet
103) Creating a Database in MySQL
104) Creating a Database Table called my_table with one column, col_string, which holds strings
105) Creating a MySQL Database Table to store Java Types
106) Creating a SQLServer Table to Store Java Types
107) Creating a Stored Procedure or Function in an Oracle Database
108) Creating a table using JdbcOdbcDriver
109) Creating an OBJECT Type in an Oracle Database
110) Creating an Oracle Table to Store Java Types
111) Creating an Updatable Result Set
112) Creating and dropping indexes
113) Creating and using a stored procedure with sun jdbc odbc JdbcOdbcDriver
114) Creating connection to the MySQL database
115) Database Browser
116) Database Info
117) Database MetaData
118) DatabaseMetaData class to obtain information about the
119) DbUtils
120) Deal with batch update exception and results
121) Debug Database connection
122) Decorates a ResultSet with checks for a SQL NULL value on each getXXX method
123) Delete a Column from a Database Table
124) DELETE data in a table
125) Delete record from table
126) Delete Records Using PreparedStatement
127) Delete Row from Updatable ResultSet for MySQL
128) Deleting a Database Table called my_table from a database
129) Deleting a Row from a Database Table
130) Deleting a Row from a Database Table Using an Updatable Result Set
131) Deleting a Table from Database
132) Deleting All Rows from a Database Table
133) Deleting Records using the Prepared Statement
134) Demo Display Binary Data From Database
135) Demo Get Generated Keys MySQL
136) Demo MySql Transaction
137) Demo Prepared Statement Add Batch MySQL
138) Demo Prepared Statement Set Ascii Stream
139) Demo Prepared Statement Set BigDecimal
140) Demo Prepared Statement Set BinaryStream
141) Demo Prepared Statement Set Blob
142) Demo PreparedStatement Set Boolean
143) Demo PreparedStatement Set Byte
144) Demo PreparedStatement Set Bytes
145) Demo PreparedStatement Set Character Stream
146) Demo PreparedStatement Set Clob
147) Demo PreparedStatement Set Date
148) Demo PreparedStatement Set Float And Double
149) Demo PreparedStatement Set Integers
150) Demo PreparedStatement Set Long
151) Demo PreparedStatement Set Null for charstring column
152) Demo PreparedStatement Set Null for int value column
153) Demo PreparedStatement Set Reference
154) Demo PreparedStatement Set Short
155) Demo PreparedStatement Set String
156) Demo PreparedStatement Set Time
157) Demo PreparedStatement Set Timestamp
158) Demo PreparedStatement Set URL
159) Demo ResultSet for MySQL
160) Demo ResultSet Oracle
161) Demo Scrollable ResultSet from MySQL
162) Demo Updatable ResultSet
163) Demonstrate simple use of the CachedRowSet
164) Designated columns table name
165) Detect if a table exists
166) Determining If a Database Supports Batching
167) Determining If a Database Supports Scrollable Result Sets
168) Determining If a Database Supports Transactions
169) Determining If a Database Supports Updatable Result Sets
170) Determining If a Result Set Is Updatable
171) Determining If a SQL Warning Occurred
172) Determining the Type of a Character
173) Disable auto commit mode in JDBC
174) Driver Property Info
175) DriverPropertyInfo[] java sql Driver getPropertyInfo(String url, Properties info)
176) Ejb and JDBC
177) Enable JDBC logging
178) Encapsulate the Connection-related operations that every JDBC program seems to use
179) Enumeration Type
180) EnumerationDriver java sql DriverManager getDrivers()
181) Escape SQL
182) Execute stored procedure
183) Executes all SQL statements in a file
184) Executes SQL queries with pluggable strategies for handling ResultSets This class is thread safe
185) Exporting a MySQL Table to a Flat File
186) FilteredRowSet Demo
187) Following up on the javadoc for java sql Connection, make a TypeMap
188) Format Timestamp
189) Get all key words in database
190) Get all table catalogs
191) Get all table schemas
192) Get all views in a database
193) Get available ResultSet types
194) Get Available Sql Types In A Database
195) Get Available Table Name In A Database
196) Get Available Table Types
197) Get BLOB data from resultset
198) Get Catalog From Database Metadata
199) Get Catalog Name From ResultSet Metadata
200) Get Column Corresponding Class Name
201) Get Column Count In ResultSet
202) Get Column Detail Information
203) Get Column Display Size zip
204) Get Column Label
205) Get Column Name
206) Get Column Name And Type For A Table
207) Get Column Name From ResultSet Metadata
208) Get Column Names From ResultSet for MySQL
209) Get Column Names From ResultSet for Oracle
210) Get column names of a table using ResultSetMetaData
211) Get Column Number Of Digits To Right Of The Decimal Point
212) Get Column Number Of Presions Number Of Decimal Digits
213) Get Column ORDINAL POSITION
214) Get Column Privileges
215) Get Column Privileges Oracle
216) Get Column Size
217) Get Column Sql Data Type
218) Get Column SQL Type Name
219) Get Column Type
220) Get columns precision and scale value
221) Get connection from DataSource
222) Get Data Truncation
223) Get data types supported by database
224) Get database maximum table name length
225) Get database product information
226) Get Database Schema From MetaData
227) Get Date From MySql
228) Get date from Oracle
229) Get Date stamp
230) Get date time functions supported by database
231) Get Driver Name
232) Get Driver Property Info
233) Get Driver Version
234) Get Error Code, SQL State, Message
235) Get Foreign Keys
236) Get Imported Keys
237) Get Index Info
238) Get Index Type
239) Get java sql Timestamp fro current time
240) Get JDBC driver information
241) Get Metadata from prepareStatement
242) Get Next SQL Warning()
243) Get Number Of Rows in a Scrollable ResultSet from MySQL
244) Get numeric functions supported by database
245) Get Object From Oracle Database Using STRUCT
246) Get Oracle Table Names
247) Get Oracle Veiw Names
248) Get Paraemter Class Name
249) Get Parameter Count From Parameter MetaData
250) Get Parameter MetaData From HSQL JDBC Driver
251) Get Parameter MetaData From Oracle JDBC Driver
252) Get Parameter Mode
253) Get Parameter Type Code
254) Get Parameter Type Name
255) Get Primary Key Column From A Table
256) Get ResultSet Metadata
257) Get RowSet MetaData From WebRowSet
258) Get SqlWarning Statement object
259) Get Stored Procedure Name And Type
260) Get Stored Procedure Signature
261) Get string functions supported by database
262) Get system functions supported by database
263) Get Table Name From ResultSet Metadata
264) Get Table Optimal Set Of Columns
265) Get Table Or View Name From A Database
266) Get Table Privileges
267) Get Table Schema Name From ResultSet Metadata
268) Get the current position of cursor
269) Get the database-specific type name
270) Get the fetch size of a statement
271) Get the java sql Types type to which this database-specific type is mapped
272) Get the max concurrent connection to a database
273) Get todays Timestamp
274) Getting an output parameter from a stored procedure
275) Getting and Inserting Binary Data into an Database Table
276) Getting BLOB Data from a Database Table
277) Getting Rows from a Database Table
278) Getting the Column Names in a Result Set
279) Getting the Cursor Position in a Scrollable Result Set
280) Getting the Maximum Table Name Length allowed in a Database
281) Getting the Name of a JDBC Type
282) Getting the Number of Rows in a Database Table
283) Getting the Number of Rows in a Table Using a Scrollable Result Set
284) Getting the Stored Procedure Names in a Database
285) Handling a SQL Exception
286) serializede-serialize a Java object to the MySQL database
287) If a table column can have a null value or not
288) If a table column value is auto-increment
289) If cursor is in the last row
290) If database support batch update
291) If database support scrollable result sets
292) If database support transaction
293) If database support updatable result sets
294) Implements DataSource
295) Implements SQLData
296) Insert a record into database table
297) Insert an Image
298) Insert BLOG(Picture or Photo) Data Type Into Oracle Database
299) Insert custom type to Oracle
300) Insert data
301) Insert data 2
302) Insert Date, time and date time data to Oracle
303) Insert picture to MySQL
304) Insert Records Using PreparedStatement
305) Insert Row
306) Insert Row 2
307) Insert Row to Updatable ResultSet from MySQL
308) Insert rows
309) Insert rows 2
310) Insert text file into MySQL
311) Insert Text File To Oracle
312) Inserting a Row into a Database Table
313) Inserting a Row into a Database Table Using a Prepared Statement
314) Inserting a Row into a Database Table Using an Updatable Result Set
315) Inserting an OBJECT Value into an Oracle Table
316) Inserting Image in Database Table
317) Inserting Records using the Prepared Statement
318) Inserting values in MySQL database table
319) Inserting with a prepared statement that uses the various setXXX() methods
320) Install Oracle Driver and Execute Resultset
321) Int java sql Driver getMajorVersion()
322) Int java sql Driver getMinorVersion()
323) Is Column A Cash Value
324) Is Column Auto Increase
325) Is Column Case Sensitive
326) Is Column Definitely Writable
327) Is Column Nullable
328) Is Column Nullable From ResultSet Metadata
329) Is Column Readonly
330) Is Column Searchable
331) Is Column Signed Number
332) Is Column Writable
333) Is Parameter Nullable
334) Is statement pooling supported
335) Issue create database command ny using Statement
336) Java database and Swing
337) Jdbc
338) JDBC Applet Policy
339) JDBC Applet running in Netscape
340) JDBC Driver Information
341) JDBC driver url
342) JDBC Mysql Connection String
343) Jdbc odbc bridge connection string
344) JDBC Performance
345) JDBC Reverse Select
346) JDBC select
347) JDBC Simple Connection
348) JDBC Transaction
349) JDBC update
350) JDBC Update logic
351) JDBC Version App
352) JdbcOdbc Connect
353) JNDI and JDBC
354) Jndi DataSource
355) Join two tables
356) List tables in a database
357) List the Tables in an SQL database
358) Listing All Available Parameters for Creating a JDBC Connection
359) Listing All Loaded JDBC Drivers and gets information about each one
360) Listing All Non-SQL92 Keywords Used by a Database
361) Listing All Table Names in a Database
362) Listing Available SQL data Types Used by a Database
363) Listing the Numeric Functions Supported by a Database
364) Listing the String Functions Supported by a Database
365) Listing the System Functions Supported by a Database
366) Listing the Time and Date Functions Supported by a Database
367) Load and save data to Derby database
368) Load driver for SQL Server
369) Load image from Derby database
370) Load MySQL JDBC Driver
371) Load MYSQL JDBC Driver and run the query
372) Load some drivers
373) Loading a Flat File to a MySQL Table, file is comma-separated
374) Loading a Flat File to a MySQL Table, file is terminated by rn, use this statement
375) Loading a JDBC Driver
376) Logging errors to a file
377) Look up DataSource from InitialContext
378) Make Unique Column in Database Table
379) Make updates in Updatable ResultSet
380) Manage Db connections providing shortcuts for Statements, PreparedStatements and ResultSets
381) Materialize binary data onto client
382) Metadata for ResultSet
383) Mini Connection Pool Manager
384) Modify data in a table
385) Move cursor backward
386) Move cursor down 5 rows from the current row If this moves cursor beyond the last row, cursor is put after the last row.
387) Move cursor in scrollable result sets
388) Move cursor to the beginning, before the first row
389) Move cursor to the end, after the last row
390) Move cursor to the first row
391) Move cursor to the last record
392) Move cursor to the last row
393) Move cursor to the second last row with absolute position
394) Move cursor up 3 rows from the current row If this moves cursor beyond the first row, cursor is put before the first row
395) Move the cursor back and forth with absolute index
396) Move to absolute or relative row
397) Moving the Cursor in a Scrollable Result Set
398) MySQL Error code and message
399) Opening an updatable ResultSet
400) Oracle Connection Pool DataSource
401) Oracle JDBC
402) Oracle JDBC Driver load
403) Oracle JDBC Driver load test
404) OracleDataSource Demo
405) Output data from table
406) Output WebRowSet in XML
407) Parse date and time
408) Pooled Connection Example
409) Predicate implementation
410) Prepared Statement Batch Update
411) Prepared Statement With Batch Update
412) PreparedStatement Set Array
413) PreparedStatement Set Object
414) Print ResultSet in HTML
415) Print the stack trace for a SQLException to STDERR
416) Print warnings on a Connection to a specified PrintWriter
417) Print warnings on a Connection to STDERR
418) Raising Custom Sql Warning
419) Read a Clob object from MySQL
420) Read BLOBs data from database
421) Read CLOBs data from database
422) Read data from Excel
423) Read data from Excel worksheet
424) Refreshing a Row in an Updatable Result Set
425) Register custome type to Oracle
426) Register RowSet Listener
427) Remove Unique Column in Database Table
428) Results Decorator SQL
429) Results Decorator Text
430) Results Decorator XML
431) ResultSet getter Methods
432) ResultSet Metadata from Oracle Driver
433) ResultSet Update
434) ResultSet Update Methods
435) Retrieve a rowcount from a ResultSet
436) Retrieve an Image
437) Retrieve auto-generated keys
438) Retrieve type info from the result set
439) Retrieving a ResultSet from JdbcOdbcDriver
440) Retrieving All Rows from a Database Table
441) Retrieving Tables from a Database
442) Return generated keys
443) Rows affected when updating data in database table
444) RowSet Model based on TableModel (JTable)
445) RowSetSync Provider
446) Save CachedRowSet Back To Database
447) Save image to derby database
448) Save Object JDBC
449) Scrollable ResultSet
450) SELECT data from a table
451) Select Records Using PreparedStatement
452) Serialized And Deserialize Object Oracle
453) Set save point
454) Set the fetch size on the statement
455) Setup hsqldb Connection and update
456) Setup JDNI Datasource
457) Setup mysql datasource
458) Simple example of JDBC-ODBC functionality
459) Specify a CharSet when connecting to a DBMS
460) SQL Batch
461) SQL Builder
462) Sql DateTime
463) SQL statement
464) Standard SQL Data Types with Their Java Equivalents
465) Statement Batch Update
466) Store and retrieve an object from a table
467) Store BLOBs data into database
468) Store CLOBs data into database
469) Stored procedure utilities
470) Stored procedure with InputOutput parms and a ResultSet
471) String java sql DriverPropertyInfo description (Get description of property)
472) String java sql DriverPropertyInfo name (Get name of property)
473) String java sql DriverPropertyInfo value (Get current value)
474) String[] java sql DriverPropertyInfo choices (Get possible choices for property; if null, value can be any string)
475) Sum of Column in a Database Table
476) Table and column existance
477) Table exist
478) Test Data Encryption Integrity
479) Test DataSource LookUp
480) Test MySQL JDBC Driver Installation
481) Test OCINet 8 App
482) Test of loading a driver and connecting to a database
483) Test Oracle JDBC Driver Installation
484) Test Register Oracle JDBC Driver
485) Test SSL
486) Test Supports Transactions
487) Test Thin Net8 App
488) This is a demonstration JDBC applet
489) This program demonstrates several complex database queries
490) This program tests that the database and the JDBC driver are correctly configured
491) This program uses metadata to display arbitrary tables in a database
492) Timestamp parse
493) Transaction Info
494) Transaction Pairs
495) Transaction Pairs 2
496) Type info in database metadata
497) Updatable resultset with Oracle Driver
498) Update Records Using PreparedStatement
499) Updating a Row in a Database Table
500) Updating a Row in a Database Table Using an Updatable Result Set
501) Use CallableStmts to call a stored procedure
502) Use DatabaseMetaData to get table column names
503) Use JDBC ODBC bridge to read from Excel
504) Use Jdbc RowSet Event
505) Use Oracle DataSource To Store MySql Connection
506) Use PreparedStatement Twice
507) Uses reflection to get all the field names from java sql Types
508) Using a database transaction with JDBC
509) Using a PreparedStatement through sun jdbc odbc JdbcOdbcDriver
510) Using DSN-less connection
511) Using INSERT with JdbcOdbcDriver
512) Using ResultSetMetaData from jdbc
513) Using the Prepared Statement Twice
514) Using UpdatableResultSet to insert a new row
515) Using UPDATE with JdbcOdbcDriver
516) Verify database setup
517) WebRowSet Demo
518) Work With Parameter MetaData
519) Wraps a ResultSet in an Iterator
520) Wraps a ResultSet to trim strings returned by the getString() and getObject() methods
521) Your own connection pool